anito.NET - Object Relational Mapping Framework

anito.zip (10,2 MB)
Anito.net is an under development, simple, open source Object Relational Mapping framework for .Net that aims to speed up database-driven development through reusable patterns and database independent solutions. Supported database MS-SQL, MySQL, SQLite and MongoDB

AppBox for ExtAsp.Net

appbox.zip (2,3 MB)
Application Box for ExtAsp.net.

arachnode.net

arachnode.zip (77,6 MB)
http://arachnode.net 2.6 release +lucene.net

ASP.NET SQL SERVER ADMIN

assa.zip (105 kB)
Web based interface for automatic adding and updating of sql server 2005 table columns' ext pros on any of the databases an SQL server login account has access to. Lists all stored procedures of the chosen database and shows their content. Generates stored procedures per table

AutoAudit

AutoAudit.zip (527 kB)
T-SQL code-gen script for audit trail triggers for SQL Server 2005-2012. Logs what, when, where, who & how SQL data and objects were created, modified & deleted

Big SQL Script File Runner

Here's project that enables any developers or others to run the big sql script file greater than 300MB or any size. It also supports rollback feature & others.

CCG Toolkit

ccgtoolkit.zip (321,3 MB)
A suite of applications (web and client based) including a database used in to create/view/modify decks and rulings with the Yu-Gi-Oh! trading card game. Data is structured to be expandable into other collectible card games (CCGs). Uses SQL 2005, WinForms, ASP.Net AJAX, WPF.

SSIS Credit Card Number Validator 05 (CCNV05)

ccnv05.zip (64 kB)
Credit Card Number Validator 05 (CCNV05) is a Custom SSIS Data Flow Transformation Component that determines whether the given input is a valid credit card number or not. CCNV05 takes String/Numeric input and performs a Synchronous, Non-Blocking transformation using Luhn Mod 10 a

Central Database Administration

centraldba.zip (12,0 MB)
The Central Database Administration project is a combination of a management database for all SQL instances and a central data warehouse for management and monitoring. It uses as much built-in functionality as possible - such as MSX, SSRS, SSIS, etc. Automate at least 1 FTE.

Crank

Crank.zip (281 kB)
A tool to assist a development team rapidly prototype a DataModel.

DAL

DAL.zip (230 kB)
OOP Data Access Layer for .net 2.0

Database Unit Testing with C#

Database Unit Testing with C# and NUnit. DatabaseUnitTesting

.Net Data Form Wizard

A Basic .Net application that will connect to a SQL Server, allow you to select a database, then select from the user created tables, read the table information, and will build the asp.net code to insert and update records. Written in VB with plans for C#

dbam.DbFramework

dbam.zip (1,4 MB)
This framework provides factory components for connecting and working with databases. The factory components provide the ability to work with many kinds of databases without requiring database platform-specific code. Also, this framework provides support for object-relational mapping of business objects to database information.

The Database Build Tool

dbbuild.zip (64 kB)
There are lots of great applications to script out and find differences in SQL Server schemas. What I think is missing is a flexible tool to reassemble your scripts and deploy them easily. This tool provides a means of combining the scripts into a single SQL file or have them run against a database in an order you specify. There is also an option for keeping track of which scripts have been applied to a database to help deploy schema changes in a much easier way.

SQL Server Database Copy Tool

dbcopytool.zip (731 kB)
Simple tool to copy databases from one SQL Server to another.

DbDiff: Database Diff and Database Scripting

DbDiff.zip (13,3 MB)
Compare MSSql database structures. (Sql 2005, Sql 2008, Sql 2008R2, Sql Denali ) Features: - compare database structures - scripting without dmo or smo - commandline scripting, commandline compare - standalone dll-s for referencing

DBSourceTools

dbsourcetools.zip (356,8 MB)
DBSourceTools is a GUI utility to help developers bring SQL Server databases under source control. A powerful database scripter, code editor, sql generator, and database versioning tool. Compare Schemas, create diff scripts, edit T-SQL with ease. Better than Management Studio.

DSQLT - Dynamic SQL Templates

dsqlt.zip (2,8 MB)
DSQLT - Dynamic SQL Templates Use Stored Procedures as templates for dynamic SQL statements. Substitute parameters @0-@9 with values like objectnames or list of columnnames. Iterate over cursor-resultset instead of constant values. Write object-independent algorithms in T-SQL.

Employee Info Starter Kit

eisk.zip (57,3 MB)
Employee Info Starter Kit is an open source project that is highly influenced by the concept ‘Pareto Principle’ or 80-20 rule, where it is targeted to enable a web developer to gain 80% productivity with 20% of effort with respect to learning curve and production.